Labels:text | screenshot | document | menu | font OCR: Query Name Informal Description Pricing Summary Report Reports the amount of business that was billed shut ged and returned 2 famiraum Cist Supplier Selecis a supplier with whorn an order should be placed for 5 given part within a given region Shipping Priority Retrieves the 10 unshipped orders with the highest valle Order Priomy Checking Determines how well the order priority system is working ans gives an assessment of customer satisfaction Lixal Supplier Volume Lists the revenue volume done through local suppliers. Forecasting Revenue Change Projects the revenue increase that would have resulted froms eliminating certain discounts in a given percentage range in a given yec! Volume Shipping Determines the value of goods shipped between corrala nations to help in the renegotiation of shipping contracts National Market Share Determines how the market share of a given nation within a given region has changed over two years for a given part type Product Type Profit Measure Determines how much profit is made on a given line of pants, broken out by supplier, nation, and year 10 Returned lem Report identifies customers who might be having problems with the parts that are shipped to them Important Stock Identification Finds the most important subset of suppliers stock in a given nation 12 Shipping Modes and Order Priority Determines whether selecting less expensive modes ofship Sales Clerk Pestokemance ping is negatively affecting the critical-promdy CIdens Measures the performance of sales clerks by the value of returned orders Promotion Effect Monitors the market response to a promotion ( such as iy advertisingì Lop'ótapier Dererinines which suppliers products comnibused the most ser enue inra given quarter of a giveryoedt 16 Parts/ Supplier Relationship Determines how many suppliers can supply paras with a given set of attributes Small-Quantity-Order Revenue Determines I ow much average yearby revemis w nuld'be lustife given minimem-order quantity wren imposed for certain parts TABLE 1 . Names and descriptions of the 17 queries used in the TPC-D benchmark.
(2000).iso/dbprd/may97/wintt101.gif){kind=small}
(2000).iso/dbprd/may97/wintf103.gif){kind=link}